/**
 * 访问数据库
 */
const mysql = require("mysql");
const pool = mysql.createPool({
    connectionLimit:10,
    host:"127.0.0.1",
    user:"test",
    password:"12345",
    database:"test",
});
/**
 *获取SQL执行结果 
 *@returns {Promise}
 */
function query(sql,values){
    return new Promise((resolve,reject)=>{
        pool.getConnection((error,connection)=>{
            if(error){
                reject(error);
            }else{
                connection.query(sql,values,(error,results)=>{
                    connection.release();
                    if(error){
                        reject(error);
                    }else{
                        resolve(results);
                    }
                });
            }
        });
    });
}

module.exports = {query};